Electcomponents

Dataset statistics

Number of variables	14
Number of observations	1912
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	209.2 KiB
Average record size in memory	112.1 B

Variable types

NUM	9
CAT	4
BOOL	1

Warnings

`width` has constant value "1912"	Constant
`height` has constant value "1912"	Constant
`counting` has constant value "1912"	Constant
`filename` has a high cardinality: 1031 distinct values	High cardinality
`area` is highly correlated with `width_obj` and 2 other fields	High correlation
`width_obj` is highly correlated with `area` and 1 other fields	High correlation
`height_obj` is highly correlated with `area` and 1 other fields	High correlation
`scale` is highly correlated with `width_obj` and 2 other fields	High correlation
`filename` is uniformly distributed	Uniform

Reproduction

Analysis started	2021-02-11 02:10:48.264261
Analysis finished	2021-02-11 02:11:08.185775
Duration	19.92 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

filename
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	1031
Distinct (%)	53.9%
Missing	0
Missing (%)	0.0%
Memory size	14.9 KiB

DJI_0029_1.jpg	5
DJI_601_2.jpg	4
DJI_03300_3.jpg	4
DJI_600_2.jpg	4
DJI_02800_3_1.jpg	4
Other values (1026)	1891

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
DJI_0029_1.jpg	5	0.3%
DJI_601_2.jpg	4	0.2%
DJI_03300_3.jpg	4	0.2%
DJI_600_2.jpg	4	0.2%
DJI_02800_3_1.jpg	4	0.2%
DJI_722_2.jpg	4	0.2%
DJI_580_5.jpg	4	0.2%
DJI_568_4.jpg	4	0.2%
DJI_0013_3000-1000.jpg	4	0.2%
DJI_568_8.jpg	4	0.2%
Other values (1021)	1871	97.9%

Frequencies of value counts

Unique

Unique	426 ?
Unique (%)	22.3%

Histogram of lengths of the category

Length

Max length	65
Median length	13
Mean length	19.70502092
Min length	13

width
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.9 KiB

600	1912

Frequencies
Length

Value	Count	Frequency (%)
600	1912	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

height
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.9 KiB

600	1912

Frequencies
Length

Value	Count	Frequency (%)
600	1912	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

class
Categorical

Distinct	4
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	14.9 KiB

missing knob	787
missing insulator	389
broken insulator	369
rusty clamp	367

Frequencies
Length

Value	Count	Frequency (%)
missing knob	787	41.2%
missing insulator	389	20.3%
broken insulator	369	19.3%
rusty clamp	367	19.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	17
Median length	12
Mean length	13.59728033
Min length	11

xmin
Real number (ℝ_≥0)

Distinct	520
Distinct (%)	27.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	263.3948745
Minimum	1
Maximum	603
Zeros	0
Zeros (%)	0.0%
Memory size	14.9 KiB

Quantile statistics

Minimum	1
5-th percentile	34.55
Q1	149.75
median	252
Q3	392
95-th percentile	506
Maximum	603
Range	602
Interquartile range (IQR)	242.25

Descriptive statistics

Standard deviation	147.0365292
Coefficient of variation (CV)	0.5582361063
Kurtosis	-0.998351046
Mean	263.3948745
Median Absolute Deviation (MAD)	115
Skewness	0.1332249282
Sum	503611
Variance	21619.74091
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	16	0.8%
256	11	0.6%
245	10	0.5%
269	10	0.5%
90	9	0.5%
497	9	0.5%
147	9	0.5%
253	9	0.5%
172	9	0.5%
82	9	0.5%
Other values (510)	1811	94.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	16	0.8%
2	3	0.2%
3	4	0.2%
4	1	0.1%
5	2	0.1%

Value	Count	Frequency (%)
603	1	0.1%
599	1	0.1%
567	1	0.1%
561	1	0.1%
558	1	0.1%

ymin
Real number (ℝ_≥0)

Distinct	523
Distinct (%)	27.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	307.542364
Minimum	1
Maximum	613
Zeros	0
Zeros (%)	0.0%
Memory size	14.9 KiB

Quantile statistics

Minimum	1
5-th percentile	59
Q1	205
median	300
Q3	439
95-th percentile	525
Maximum	613
Range	612
Interquartile range (IQR)	234

Descriptive statistics

Standard deviation	146.7867888
Coefficient of variation (CV)	0.4772896549
Kurtosis	-0.9356396286
Mean	307.542364
Median Absolute Deviation (MAD)	118.5
Skewness	-0.1505527284
Sum	588021
Variance	21546.36136
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	17	0.9%
473	13	0.7%
272	11	0.6%
264	11	0.6%
475	11	0.6%
247	11	0.6%
477	11	0.6%
271	11	0.6%
266	11	0.6%
268	9	0.5%
Other values (513)	1796	93.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	17	0.9%
2	1	0.1%
3	3	0.2%
4	1	0.1%
6	2	0.1%

Value	Count	Frequency (%)
613	1	0.1%
611	1	0.1%
600	1	0.1%
596	1	0.1%
592	1	0.1%

xmax
Real number (ℝ_≥0)

Distinct	510
Distinct (%)	26.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	351.9027197
Minimum	32
Maximum	640
Zeros	0
Zeros (%)	0.0%
Memory size	14.9 KiB

Quantile statistics

Minimum	32
5-th percentile	108
Q1	227
median	362
Q3	475
95-th percentile	577
Maximum	640
Range	608
Interquartile range (IQR)	248

Descriptive statistics

Standard deviation	147.6958454
Coefficient of variation (CV)	0.4197064619
Kurtosis	-1.029236854
Mean	351.9027197
Median Absolute Deviation (MAD)	124
Skewness	-0.1575395354
Sum	672838
Variance	21814.06275
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
353	11	0.6%
371	11	0.6%
595	10	0.5%
234	10	0.5%
327	10	0.5%
346	10	0.5%
375	10	0.5%
199	10	0.5%
481	9	0.5%
423	9	0.5%
Other values (500)	1812	94.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
32	1	0.1%
35	1	0.1%
37	1	0.1%
44	1	0.1%
47	1	0.1%

Value	Count	Frequency (%)
640	5	0.3%
613	1	0.1%
600	8	0.4%
599	1	0.1%
598	3	0.2%

ymax
Real number (ℝ_≥0)

Distinct	483
Distinct (%)	25.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	388.7588912
Minimum	19
Maximum	640
Zeros	0
Zeros (%)	0.0%
Memory size	14.9 KiB

Quantile statistics

Minimum	19
5-th percentile	180.55
Q1	306
median	379
Q3	492
95-th percentile	585.45
Maximum	640
Range	621
Interquartile range (IQR)	186

Descriptive statistics

Standard deviation	123.5412588
Coefficient of variation (CV)	0.3177837512
Kurtosis	-0.5204190675
Mean	388.7588912
Median Absolute Deviation (MAD)	92
Skewness	-0.1977835805
Sum	743307
Variance	15262.44262
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
347	12	0.6%
352	12	0.6%
499	12	0.6%
372	11	0.6%
357	11	0.6%
295	11	0.6%
488	11	0.6%
519	11	0.6%
419	11	0.6%
308	11	0.6%
Other values (473)	1799	94.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
19	1	0.1%
27	1	0.1%
30	1	0.1%
34	2	0.1%
53	1	0.1%

Value	Count	Frequency (%)
640	6	0.3%
628	1	0.1%
623	1	0.1%
622	1	0.1%
615	2	0.1%

counting
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.9 KiB

1	1912

Common Values
Chart

Value	Count	Frequency (%)
1	1912	100.0%

width_obj
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	263
Distinct (%)	13.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	88.50784519
Minimum	19
Maximum	500
Zeros	0
Zeros (%)	0.0%
Memory size	14.9 KiB

Quantile statistics

Minimum	19
5-th percentile	35
Q1	50
median	69
Q3	97
95-th percentile	236
Maximum	500
Range	481
Interquartile range (IQR)	47

Descriptive statistics

Standard deviation	67.92371857
Coefficient of variation (CV)	0.767431615
Kurtosis	9.590652458
Mean	88.50784519
Median Absolute Deviation (MAD)	21
Skewness	2.836652853
Sum	169227
Variance	4613.631545
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
66	35	1.8%
48	34	1.8%
70	32	1.7%
52	31	1.6%
67	31	1.6%
69	31	1.6%
59	30	1.6%
50	29	1.5%
41	29	1.5%
61	28	1.5%
Other values (253)	1602	83.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
19	1	0.1%
21	1	0.1%
22	2	0.1%
23	1	0.1%
24	3	0.2%

Value	Count	Frequency (%)
500	1	0.1%
498	2	0.1%
489	1	0.1%
478	1	0.1%
469	1	0.1%

height_obj
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	259
Distinct (%)	13.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	81.2165272
Minimum	15
Maximum	512
Zeros	0
Zeros (%)	0.0%
Memory size	14.9 KiB

Quantile statistics

Minimum	15
5-th percentile	26
Q1	39
median	57
Q3	96
95-th percentile	222.45
Maximum	512
Range	497
Interquartile range (IQR)	57

Descriptive statistics

Standard deviation	72.44846364
Coefficient of variation (CV)	0.8920408954
Kurtosis	9.799948163
Mean	81.2165272
Median Absolute Deviation (MAD)	23
Skewness	2.864488295
Sum	155286
Variance	5248.779884
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	38	2.0%
44	37	1.9%
36	37	1.9%
40	36	1.9%
39	36	1.9%
37	36	1.9%
42	35	1.8%
38	35	1.8%
30	34	1.8%
47	33	1.7%
Other values (249)	1555	81.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
15	2	0.1%
16	2	0.1%
17	7	0.4%
18	4	0.2%
19	10	0.5%

Value	Count	Frequency (%)
512	1	0.1%
498	1	0.1%
487	1	0.1%
480	1	0.1%
474	1	0.1%

aspect_ratio
Real number (ℝ_≥0)

Distinct	1415
Distinct (%)	74.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.287387278
Minimum	0.4
Maximum	5.277777778
Zeros	0
Zeros (%)	0.0%
Memory size	14.9 KiB

Quantile statistics

Minimum	0.4
5-th percentile	0.6165617021
Q1	0.8284798535
median	1.088279221
Q3	1.639508197
95-th percentile	2.410549002
Maximum	5.277777778
Range	4.877777778
Interquartile range (IQR)	0.8110283432

Descriptive statistics

Standard deviation	0.606270237
Coefficient of variation (CV)	0.4709307351
Kurtosis	3.083955024
Mean	1.287387278
Median Absolute Deviation (MAD)	0.3531107944
Skewness	1.332219108
Sum	2461.484475
Variance	0.3675636003
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	35	1.8%
1.333333333	12	0.6%
2	10	0.5%
1.571428571	6	0.3%
0.6666666667	6	0.3%
0.75	6	0.3%
1.083333333	6	0.3%
1.125	5	0.3%
1.051282051	5	0.3%
0.7142857143	5	0.3%
Other values (1405)	1816	95.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.4	1	0.1%
0.4078947368	1	0.1%
0.4084507042	1	0.1%
0.4384615385	1	0.1%
0.4402985075	1	0.1%

Value	Count	Frequency (%)
5.277777778	1	0.1%
5.166666667	1	0.1%
5.052631579	1	0.1%
4.117647059	1	0.1%
4.086956522	1	0.1%

area
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1432
Distinct (%)	74.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11424.81747
Minimum	345
Maximum	256000
Zeros	0
Zeros (%)	0.0%
Memory size	14.9 KiB

Quantile statistics

Minimum	345
5-th percentile	1080.55
Q1	2109
median	3768.5
Q3	8551.5
95-th percentile	54056.1
Maximum	256000
Range	255655
Interquartile range (IQR)	6442.5

Descriptive statistics

Standard deviation	26288.56658
Coefficient of variation (CV)	2.301005391
Kurtosis	29.6447425
Mean	11424.81747
Median Absolute Deviation (MAD)	2094.5
Skewness	5.057784096
Sum	21844251
Variance	691088732.9
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1560	7	0.4%
2016	6	0.3%
1925	6	0.3%
1599	6	0.3%
2730	5	0.3%
1890	5	0.3%
1188	5	0.3%
2736	5	0.3%
1404	5	0.3%
3120	5	0.3%
Other values (1422)	1857	97.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
345	1	0.1%
361	1	0.1%
432	1	0.1%
440	1	0.1%
459	1	0.1%

Value	Count	Frequency (%)
256000	1	0.1%
248004	1	0.1%
223533	1	0.1%
217566	1	0.1%
214622	1	0.1%

scale
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1432
Distinct (%)	74.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1382907225
Minimum	0.03095695937
Maximum	0.8432740427
Zeros	0
Zeros (%)	0.0%
Memory size	14.9 KiB

Quantile statistics

Minimum	0.03095695937
5-th percentile	0.05478619916
Q1	0.07653975002
median	0.1023134888
Q3	0.1541238662
95-th percentile	0.3874976871
Maximum	0.8432740427
Range	0.8123170833
Interquartile range (IQR)	0.07758411613

Descriptive statistics

Standard deviation	0.1123293349
Coefficient of variation (CV)	0.8122694919
Kurtosis	10.6469867
Mean	0.1382907225
Median Absolute Deviation (MAD)	0.03192606325
Skewness	3.012836261
Sum	264.4118613
Variance	0.01261787947
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.06582805886	7	0.4%
0.06664583008	6	0.3%
0.07312470323	6	0.3%
0.07483314774	6	0.3%
0.08774964387	5	0.3%
0.06749485577	5	0.3%
0.07245688373	5	0.3%
0.06244997998	5	0.3%
0.07745966692	5	0.3%
0.05744562647	5	0.3%
Other values (1422)	1857	97.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.03095695937	1	0.1%
0.03166666667	1	0.1%
0.03464101615	1	0.1%
0.03496029494	1	0.1%
0.03570714214	1	0.1%

Value	Count	Frequency (%)
0.8432740427	1	0.1%
0.83	1	0.1%
0.7879879441	1	0.1%
0.7773995112	1	0.1%
0.772121896	1	0.1%

Pearson\'s r

The Pearson\'s correlation coefficient (r) is a measure of linear correlation between two variables. It\'s value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman\'s ρ

The Spearman\'s rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson\'s r. It\'s value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall\'s τ

Similarly to Spearman\'s rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It\'s value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	filename	width	height	class	xmin	ymin	xmax	ymax	counting	width_obj	height_obj	aspect_ratio	area	scale
0	ABESAN0015_3.jpg	600	600	broken insulator	173	137	395	277	1	222	140	1.585714	31080	0.293825
1	ABESAN0054_2.jpg	600	600	broken insulator	215	119	371	237	1	156	118	1.322034	18408	0.226127
2	ABESAN0054_3.jpg	600	600	broken insulator	146	155	481	411	1	335	256	1.308594	85760	0.488080
3	ABESAN0075_2.jpg	600	600	broken insulator	183	119	437	296	1	254	177	1.435028	44958	0.353388
4	ABESAN0075_3.jpg	600	600	broken insulator	168	88	448	303	1	280	215	1.302326	60200	0.408928
5	ADIYAN0024_02.jpg	600	600	missing insulator	234	126	333	246	1	99	120	0.825000	11880	0.181659
6	ADIYAN0024_03.jpg	600	600	missing insulator	176	1	465	350	1	289	349	0.828080	100861	0.529310
7	ADIYAN0024_03_jpg.rf.429af7288fa432a34a1086ad4ec9df15.jpg	600	600	missing insulator	128	1	504	399	1	376	398	0.944724	149648	0.644739
8	ADIYAN0024_03_jpg.rf.8a34828000d4a41c0bacb3795be2f8d7.jpg	600	600	missing insulator	177	1	584	424	1	407	423	0.962175	172161	0.691538
9	ADIYAN0029_02.jpg	600	600	missing insulator	254	194	368	314	1	114	120	0.950000	13680	0.194936

Last rows

	filename	width	height	class	xmin	ymin	xmax	ymax	counting	width_obj	height_obj	aspect_ratio	area	scale
1902	SPINTEX0081_02.jpg	600	600	missing insulator	277	199	350	276	1	73	77	0.948052	5621	0.124956
1903	SPINTEX0081_03.jpg	600	600	missing insulator	177	33	450	323	1	273	290	0.941379	79170	0.468953
1904	YIDI0081-1_2.jpg	600	600	missing insulator	172	236	279	322	1	107	86	1.244186	9202	0.159878
1905	YIDI0081-1_2_jpg.rf.24b3c12eeeb7cade70c6b7ddc131a3db.jpg	600	600	missing insulator	183	217	318	336	1	135	119	1.134454	16065	0.211246
1906	YIDI0081-2_2.jpg	600	600	missing insulator	207	139	394	291	1	187	152	1.230263	28424	0.280990
1907	YIDI0081-2_2_jpg.rf.4ef9593b4cb9f6b2b4d43a6e6e9c921a.jpg	600	600	missing insulator	227	130	460	335	1	233	205	1.136585	47765	0.364253
1908	YIDI0081-2_2_jpg.rf.ef05ec2d13b4cb08d939d8980554a344.jpg	600	600	missing insulator	226	130	459	335	1	233	205	1.136585	47765	0.364253
1909	YIDI0081-2_3.jpg	600	600	missing insulator	177	82	547	399	1	370	317	1.167192	117290	0.570794
1910	YIDI0081-2_3_jpg.rf.c22ec6f8750b78c84df9c0a903ea8cc1.jpg	600	600	missing insulator	7	61	476	490	1	469	429	1.093240	201201	0.747591
1911	YIDI0081-2_3_jpg.rf.e8e1c0659412e16d51414343e92ab63f.jpg	600	600	missing insulator	162	57	640	506	1	478	449	1.064588	214622	0.772122

Overview

Variables

Interactions

Correlations

Pearson\'s r

Spearman\'s ρ

Kendall\'s τ

Phik (φk)

Missing values

Sample

First rows

Last rows